1.概述
可以通过下图直观看出 LEFT JOIN、RIGHT JOIN、INNER JOIN、OUTER JOIN等相关的7 种用法。 ![在这里插入图片描述](https://img-blog.csdnimg.cn/cfdfc9325b6f4d0aaaa16aac84e741d3.png)
2.语句
以下就是这七种用法的语句:
(1)、Inner JOIN
![在这里插入图片描述](https://img-blog.csdnimg.cn/622436bb257d41b983005510bcd27fd2.png)
SELECT
FROM Table_A A
INNER JOIN Table_B B
ON A.Key = B.Key
(2)、Left JOIN
![在这里插入图片描述](https://img-blog.csdnimg.cn/859250945af24601a8535b043c083a44.png)
SELECT
FROM Table_A A
LEFT JOIN Table_B B
ON A.Key = B.Key
(3)、Right JOIN
![在这里插入图片描述](https://img-blog.csdnimg.cn/2d1f28e7a9ba478fb38f6bccd0db08b3.png)
SELECT
FROM Table_A A
RIGHT JOIN Table_B B
ON A.Key = B.Key
(4)、Outer JOIN
![在这里插入图片描述](https://img-blog.csdnimg.cn/2f63d81dded2413cabcce3438fda91f0.png)
SELECT
FROM Table_A A
FULL OUTER JOIN Table_B B
ON A.Key = B.Key
(5)、Left Excluding JOIN
![在这里插入图片描述](https://img-blog.csdnimg.cn/57b3b69ea11448f79414eb66857f6c16.png)
SELECT
FROM Table_A A
LEFT JOIN Table_B B
ON A.Key = B.Key
WHERE B.Key IS NULL
(6)、Right Excluding JOIN
![在这里插入图片描述](https://img-blog.csdnimg.cn/70117caf8559457da86bdf06d0910bdc.png)
SELECT
FROM Table_A A
RIGHT JOIN Table_B B
ON A.Key = B.Key
WHERE A.Key IS NULL
(7)、Outer Excluding JOIN
![在这里插入图片描述](https://img-blog.csdnimg.cn/6f06424333784431825a1af8f2390ad3.png)
SELECT
FROM Table_A A
FULL OUTER JOIN Table_B B
ON A.Key = B.Key
WHERE A.Key IS NULL OR B.Key IS NULL
3.说明
以上的图片以及语句均来自菜鸟教程,略加进行了整理。我们可以看出这七条语句经过图片展示后非常直观的给出了要查询的内容。
|